#ifndef _SQLITE_H_
#define _SQLITE_H_

#include<stdio.h>
#include<stdlib.h>
#include<sqlite3.h>
#include<string.h>
#include"employee_errono.h"
#include"info.h"

sqlite3 * open_mydb(const char *path);

int create_table(sqlite3 *db);

int user_compare(sqlite3 *db,char *work_num,char *passwd,int *type);

int inset_user(sqlite3 *db,Mesg *user);

int select_userinfo(sqlite3 *db,Mesg *user);

int passwd_update(sqlite3 *db,char * work_num, char *  passwd);

int delete_user(sqlite3 *db,char * work_num);

int info_update(sqlite3 *db,Mesg *user);

int close_mydb(sqlite3 *db);
int NULLCallback(void *para, int f_num, char **f_value, char **f_name);
#endif

